$webwork.htmlEncode($page.space.name) : DB2 DataStore
This page last changed on Jul 24, 2007 by cholmes.
IntroductionThe DB2 datastore is new with GeoTools 2.1 and GeoServer 1.3. The IBM DB2 UDB database is a commercial relational database (RDBMS) implementing ISO SQL standards and is similar in functionality to Oracle, SQL Server, MySQL, PostGres and other RDBMS. The DB2 Spatial Extender is a no-charge licensed feature of DB2 UDB which implements the OGC specification "Simple Features for SQL using types and functions" and the ISO "SQL/MM Part 3 Spatial" standard. If you are interested in trying it out, a trial copy of DB2 UDB and Spatial Extender can be downloaded from: Note also there is now an 'Express-C' version of DB2, that is free, comes with spatial support, and has no limits on size. We have not yet had a chance to test it against GeoServer, but are reasonably confident it should work. If you try it out please let us know. It can be found at: http://www-306.ibm.com/software/data/db2/express/download.html InstallationThese instructions assume that you have already installed a copy of DB2 UDB, the DB2 Spatial Extender and latest fixpacks. You should have also created and spatially-enabled a database using the instructions in the "User's Guide and Reference" which can be found at: You need to copy the gt2-db2.jar file to the HOME/webapps/geoserver/WEB-INF/lib/ directory. The DB2 JDBC driver also needs to be copied to the above directory. The DB2 JDBC driver consists of the files db2jcc.jar and ConfigurationAfter installing the the jar files you should restart GeoServer. You should now be able to use the GeoServer Administration GUI to Create New DataStore and see 'DB2' listed in the drop-down list of Note that in general, DB2 schema, table and column names are all case-sensitive when working with GeoTools/GeoServer. When working with DB2 scripts and the DB2 command window, the default is to treat these names as upper-case unless enclosed in double-quote characters. The params needed are as follows:
The following is an example of a DB2 datastore definition in the GeoServer catalog.xml file. <datastore id="cdf" enabled="true" namespace="cdf"> <description>A sample DB2 testing database</description> <connectionParams> <parameter name="dbtype" value="db2"/> <parameter name="host" value="localhost"/> <parameter name="port" value="50000"/> <parameter name="database" value="cite"/> <parameter name="user" value="db2admin"/> <parameter name="passwd" value="adminpw"/> <parameter name = "tabschema" value = "cdf" /> </connectionParams> </datastore> DocumentationGeneral information about DB2 UDB and DB2 Spatial Extender can be found at: "IBM DB2 UDB Spatial Extender User's Guide and Reference" which can be found at: Another good reference is the DB2 Information Center at: DB2 fixpacks and other support information can be found at: SupportQuestions and problems can be reported to the [email protected] BugsFor any problems please make use of our JIRA task tracker at:
|
![]() |
Document generated by Confluence on Jan 16, 2008 23:27 |